Question 1

____ operators perform mathematical calculations such as adding and subtracting.

Accepted Answer

A)  Text concatenation 
B)  Reference 
C)  Arithmetic 
D)  Comparison 
A)  Text concatenation 
B)  Reference 
C)  Arithmetic 
D)  Comparison C

Question 2

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Accepted Answer

A)  Cell pointers 
B)  Mode indicators 
C)  Scroll bars 
D)  Sheet tabs 
A)  Cell pointers 
B)  Mode indicators 
C)  Scroll bars 
D)  Sheet tabs D

Question 3

To quickly jump to the last cell in a worksheet press ____.

Accepted Answer

A)  [Alt][Page Down] 
B)  [Shift][Down] 
C)  [Page Down] 
D)  [Ctrl][End] 
A)  [Alt][Page Down] 
B)  [Shift][Down] 
C)  [Page Down] 
D)  [Ctrl][End] D

Question 4

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

Accepted Answer

A) True 
 B)False

Question 5

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Accepted Answer

A) True 
 B)False

Question 6

A named range must begin with a letter or a(n) _____.​

Accepted Answer

A)  ​underscore (_) 
B)  ​asterisk (*) 
C)  ​ampersand (&) 
D)  ​pound symbol (#) 
A)  ​underscore (_) 
B)  ​asterisk (*) 
C)  ​ampersand (&) 
D)  ​pound symbol (#)

Question 7

You can use a named range instead of a cell address in a formula.

Accepted Answer

A) True 
 B)False

Question 8

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

Accepted Answer

A) True 
 B)False

Question 9

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have created a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in  cells B6 through E6.  Write the complete formulas for the Total row, cell C8 to calculate the second quarter sales for the three stores.

Accepted Answer

A)  =SUM(C4:C6) 
B)  =TOT(C4-C6) 
C)  =TOT(C4:C6) 
D)  =SUM(C4_C6) 
A)  =SUM(C4:C6) 
B)  =TOT(C4-C6) 
C)  =TOT(C4:C6) 
D)  =SUM(C4_C6)

Question 10

You can use ____ to move around in a document that is too large to fit on the screen at once.

Accepted Answer

A)  cell pointers 
B)  mode indicators 
C)  scroll bars 
D)  sheet tabs 
A)  cell pointers 
B)  mode indicators 
C)  scroll bars 
D)  sheet tabs

Question 11

To open an Excel file, click Open Other Workbooks on the navigation bar, click This PC, and then click Browse to open the Open dialog box.

Accepted Answer

A) True 
 B)False

Question 12

The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.​

Accepted Answer

A) True 
 B)False

Question 13

Explain the difference between Normal view and Page Layout view in Excel.

Accepted Answer

Normal view shows the worksheet without

Question 14

Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. ____________________

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Provides a brief description of the active command or task in progress

Accepted Answer

The Answer of Name box and cell pointer and cell is...

Question 16

The Excel operator for division is ____.

Accepted Answer

A)  / 
B)  \ 
C)  % 
D)  ^ 
A)  / 
B)  \ 
C)  % 
D)  ^

Question 17

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​

Accepted Answer

A)  ​name box 
B)  ​taskbar 
C)  ​insert bar 
D)  ​formula bar 
A)  ​name box 
B)  ​taskbar 
C)  ​insert bar 
D)  ​formula bar

Question 18

In a worksheet, the ____ is called the formula prefix.

Accepted Answer

A)  minus sign (-) 
B)  plus sign (+) 
C)  pound sign (#) 
D)  equal sign (=) 
A)  minus sign (-) 
B)  plus sign (+) 
C)  pound sign (#) 
D)  equal sign (=)

Question 19

Match between columns
                        Premises: Displays the active cell address

Accepted Answer

The Answer of range and cell address and status bar is...

Question 20

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

Accepted Answer

A)  =A1^A2 
B)  20 
C)  10^2 
D)  100 
A)  =A1^A2 
B)  20 
C)  10^2 
D)  100

Exam 6: Excel 1: Getting Started With Excel 2016

____ operators perform mathematical calculations such as adding and subtracting.

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

To quickly jump to the last cell in a worksheet press ____.

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

A named range must begin with a letter or a(n) _____.​

You can use a named range instead of a cell address in a formula.

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

You can use ____ to move around in a document that is too large to fit on the screen at once.

To open an Excel file, click Open Other Workbooks on the navigation bar, click This PC, and then click Browse to open the Open dialog box.

The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.​

Explain the difference between Normal view and Page Layout view in Excel.

Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. ____________________

The Excel operator for division is ____.

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​

In a worksheet, the ____ is called the formula prefix.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 3: Using Forms

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

A named range must begin with a letter or a(n) _____.

The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.