Which function reverses the value of the function arguments?
NOT
100
Which of the following is NOT a way to insert a new worksheet into a workbook?
On the Insert tab, click New Sheet
100
To enter data in multiple worksheets at one time, you must:
group all worksheets and enter data in the open worksheet
100
What is the process of bringing data containing text fields separated by commas into Excel called?
What is Importing data
100
David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What
command should he use to complete this task?
What is Sort
200
Which function returns one value if a condition is true and a different value when the condition is not true?
IF
200
You can tell that worksheets are grouped by:
the word "group" in the title bar.
200
To insert multiple worksheets at one time, what action is needed in addition to selecting the same number of tabs as the number of sheets to insert?
Press and hold Ctrl as you select the tabs.
200
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
What is Text
200
What area contains the command used to customize the print options in Microsoft Excel?
What is File Tab
300
Criteria range in a formula refers to:
the range containing a condition that must be met in order for data to be included in the result.
300
When a worksheet is hidden:
Unhide is active on the shortcut menu
300
When Sheet1 has been copied, the new worksheet tab is named:
Sheet 1 (2).
300
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this
problem?
What is AutoFit
300
How do you quickly modify a table style to meet user preferences?
What is Right-click on a style and choose Duplicate.
400
In ______ sorted values appear Z to A or highest to lowest.
descending order
400
To hide a workbook that has multiple worksheets:
click Hide in the Window group on the View tab.
400
When you use the Freeze command,
the column and/or row headings remain visible as you scroll through the worksheet card.
400
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
What is Template
400
What command do you use to apply a background color to cells in a worksheet?
What is Fill Color
500
A sign used in criteria to compare two values is a(n)
comparison operator
500
If you want to magnify the data on the screen:
increase zoom to more than 100%.
500
To find data using the Find and Replace dialog box, you must enter a sequence of characters called a:
string
500
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know
how many members are in the same first period class. Which feature would allow him to do this?
What is Subtotal
500
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he
select?