Filters
Question type
Study Flashcards

Which of the following is the path to the Spelling button?


A) (HOME tab | Proofing group)
B) (PROOFING tab | Spelling group)
C) (REVIEW tab | Proofing group)
D) (REVIEW tab | Checking group)

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

Correct Answer

verifed

verified

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.


A) AutoCorrect
B) Insert
C) Auto Fill
D) Paste

E) A) and D)
F) All of the above

Correct Answer

verifed

verified

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Copies a formula.

Correct Answer

verifed

verified

The default font for the Basis theme is different than the default font for the Office theme.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is the path to the Copy and Paste buttons?


A) (HOME tab | Copy group)
B) (HOME tab | Paste group)
C) (HOME tab | Clipboard group)
D) (HOME tab | Formulas group)

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

The default view in Excel is called ____ view.


A) Normal
B) Standard
C) Basic
D) Values

E) A) and C)
F) A) and D)

Correct Answer

verifed

verified

Which of the following are valid formulas?


A) =3 ^ 4
B) =H3/H11
C) =11+9
D) =22-F15

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

-Point mode allows you to ____,as shown in the accompanying figure. A) select cells for use in a formula using the keyboard B) select a function from the Sum button list C) select cells for use in a formula using the mouse pointer D) edit cell contents directly in the cell -Point mode allows you to ____,as shown in the accompanying figure.


A) select cells for use in a formula using the keyboard
B) select a function from the Sum button list
C) select cells for use in a formula using the mouse pointer
D) edit cell contents directly in the cell

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Correct Answer

verifed

verified

The arithmetic operator,^,directs Excel to perform the division operation.

A) True
B) False

Correct Answer

verifed

verified

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

A) True
B) False

Correct Answer

verifed

verified

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.


A) Normal
B) Page Layout
C) Page Break Preview
D) Full Screen

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

The / arithmetic operator indicates ____________________.

Correct Answer

verifed

verified

All of the following are valid Excel arithmetic operators EXCEPT ____.


A) ^
B) *
C) %
D) >

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

You can use the arrow keys to complete an entry in Point mode.

A) True
B) False

Correct Answer

verifed

verified

Which of the following happens when you enter the formula =G15 into a cell?


A) Excel recalculates all formulas in the worksheet
B) Excel assigns the sum of the values in the previous 15 cells to the active cell
C) Excel assigns the value in cell G15 to the active cell
D) Nothing;=G15 is an invalid formula

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.


A) placement
B) operations
C) positioning
D) selections

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

The equal sign (=)precedes a formula.

A) True
B) False

Correct Answer

verifed

verified

The most common error when entering a formula is to reference the wrong cell in the formula.

A) True
B) False

Correct Answer

verifed

verified

Showing 61 - 80 of 103

Related Exams

Exam 1

Introduction to Technology

45 Questions

Exam 2

Office 365 Essentials

59 Questions

Exam 3

Office 2013 and Windows 8 Essential Concepts and Skills

109 Questions

Exam 4

Access: Databases and Database Objects: an Introduction

105 Questions

Exam 5

Access: Querying a Database

105 Questions

Exam 6

Access: Maintaining a Database

105 Questions

Exam 7

Excel: Creating a Worksheet and a Chart

105 Questions

Exam 9

Excel: Working With Large Worksheets, Charting, and What-If Analysis

105 Questions

Exam 10

Outlook: Managing Email Messages With Outlook

109 Questions

Exam 11

Outlook: Managing Calendars With Outlook

109 Questions

Exam 12

Powerpoint: Creating and Editing a Presentation With Pictures

108 Questions

Exam 13

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

109 Questions

Exam 14

Powerpoint: Reusing a Presentation and Adding Media and Animation

107 Questions

Exam 15

Word: Creating, Formatting, and Editing a Word Document With a Picture

112 Questions

Exam 16

Word: Creating a Research Paper With References and Sources

107 Questions

Exam 17

Word: Creating a Business Letter With a Letterhead and Table

112 Questions

Show Answer