Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/36
Score 0
A spreadsheet is a software program that allows you to
30
All of these
Enter data quickly and accurately
Chart data
Analyze and calculate data
Q 2/36
Score 0
A collection of worksheets are stored in a
30
Workbook
All of these
Spreadsheet
Book
36 questions
Q.
A spreadsheet is a software program that allows you to
1
30 sec
Q.
A collection of worksheets are stored in a
2
30 sec
Q.
The spreadsheet formula, =E6-(F6+G6) directs the spreadsheet to
3
45 sec
Q.
Which of the following built-in formulas is used to total numeric values?
4
30 sec
Q.
Which spreadsheet command allows you to make changes to the font, cells, rows, and columns?
5
30 sec
Q.
How do you format data into dollars and cents?
6
30 sec
Q.
How do you increase the width of a column?
7
30 sec
Q.
What may need to be done to a column when ##### appears after entering data into a cell?
8
30 sec
Q.
Which icon on the image would you click to merge cells?
9
30 sec
Q.
The tool that allows you to automatically change the width of a column to fit the longest entry, or change the height of a row to fit the contents is called___________
10
30 sec
Q.
How do you insert a new column?
11
30 sec
Q.
A pie chart compares data:
12
30 sec
Q.
How do you change the label for Worksheet #1
13
30 sec
Q.
When you want to repeat the same information at the top or bottom of every page of a spreadsheet, you would which of the following?
14
30 sec
Q.
How would you print a range of cells?
15
30 sec
Q.
True or False: You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
16
30 sec
Q.
___________ lets you switch from sheet to sheet in a workbook.
17
30 sec
Q.
In Excel, the electronic spreadsheet is called a ___________
18
30 sec
Q.
All Excel formulas begin with the _____.
19
30 sec
Q.
The Excel operator for exponent is
20
30 sec
Q.
A(n) ______________ is a built-in formula.
21
30 sec
Q.
The ____________ sheet button allows you to add worksheets to a workbook.
22
30 sec
Q.
While you are entering a formula in a cell, the cell references and arithmetic operators appear in the
23
30 sec
Q.
To quickly jump to the first cell in a worksheet press
24
30 sec
Q.
In a worksheet, the ___________________ is called the formula prefix
25
30 sec
Q.
The cell in which you are working is called the ____________cell
26
30 sec
Q.
A ____________ is an equation in a worksheet
27
30 sec
Q.
This displays the active cell address
28
30 sec
Q.
This is a selection of two or more cells
29
30 sec
Q.
This is identified by the coordinates of the intersecting column and row.
30
30 sec
Q.
This provides a brief description of the active command or task in progress
31
30 sec
Q.
The intersection of a row and a column is
32
30 sec
Q.
____________ contain text and numerical information not used in calculations
33
30 sec
Q.
______________ are numbers, formulas, and functions that can be used in calculations
34
30 sec
Q.
This view shows the worksheet without headers or footers.
35
30 sec
Q.
This view shows the margins, headers, footers, rulers, etc.
