Exam 1: Introduction to Excel

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Which of the following is not included when you use a cell style?

Free
(Multiple Choice)
4.9/5
(38)
Correct Answer:
Verified

B

The ________ color is what is visible behind the value in a cell.

Free
(Short Answer)
4.9/5
(25)
Correct Answer:
Verified

fill

Match the following terms with their description:
Formula
PEMDAS
Fill handle
Small green square used to perform various actions
Order of operations
Displays the address of the active cell
Correct Answer:
Verified
Premises:
Responses:
Formula
PEMDAS
Fill handle
Small green square used to perform various actions
Order of operations
Displays the address of the active cell
Pointing
Always begins with an equals sign (=)
Name Box
Also known as semi-selection
Free
(Matching)
4.9/5
(42)
Correct Answer:
Verified

A(n)________ range contains several ranges.

(Short Answer)
4.9/5
(39)

________ can be used in calculations, whereas text cannot.

(Short Answer)
4.8/5
(36)

A(n)________ is a group of cells which have been selected at the same time.

(Short Answer)
4.8/5
(25)

Which keyboard shortcut puts the user in cell edit mode?

(Multiple Choice)
4.9/5
(32)

Which of the following is not considered an Excel element?

(Multiple Choice)
4.8/5
(37)

The cell at row 4 and column B, would be identified as 4B.

(True/False)
4.8/5
(31)

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

(Short Answer)
4.8/5
(31)
Match the following terms with their description:
Page Break Preview
Allows you to go to the first, previous, next, or last sheet in a workbook
Normal view
Icons that let you change views
Page Layout view
Displays data and page breaks
Correct Answer:
Verified
Premises:
Responses:
Page Break Preview
Allows you to go to the first, previous, next, or last sheet in a workbook
Normal view
Icons that let you change views
Page Layout view
Displays data and page breaks
Sheet tab navigation
Displays data and margins
View controls
Does not display margins or page breaks
(Matching)
4.8/5
(41)

The ________ area is where you store the variable you will be using in the worksheet.

(Short Answer)
4.9/5
(38)

What is not one of the tabs in Excel?

(Multiple Choice)
4.8/5
(40)

What can you not do directly from the Backstage, Print screen view?

(Multiple Choice)
4.9/5
(42)

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

(Short Answer)
4.8/5
(38)
Match the following terms with their description:
Accounting number format
Puts the $ at the left margin of the cell
Currency number format
Puts the $ next to the leftmost number
Transpose
Sums the values of the pasted cells to the cells already there
Correct Answer:
Verified
Premises:
Responses:
Accounting number format
Puts the $ at the left margin of the cell
Currency number format
Puts the $ next to the leftmost number
Transpose
Sums the values of the pasted cells to the cells already there
Paste Special , Add
Fills in data based on previous column's data
Flash Fill
Flips rows and columns when pasted
(Matching)
4.8/5
(40)

A(n)________ is a collection of one or more related worksheets.

(Short Answer)
4.8/5
(40)
Match the following terms with their description:
Cell
Shows the name of the worksheet
Zoom control
The same as a spreadsheet
Worksheet
Makes the text on the screen smaller or larger
Correct Answer:
Verified
Premises:
Responses:
Cell
Shows the name of the worksheet
Zoom control
The same as a spreadsheet
Worksheet
Makes the text on the screen smaller or larger
Sheet tab
Contain labels, values and formulas
Workbook
The intersection of a column and a row
(Matching)
4.8/5
(36)

The best way to apply Page Setup options to multiple worksheets is to ________.

(Multiple Choice)
4.9/5
(34)

How is text aligned by default?

(Multiple Choice)
4.8/5
(37)
Showing 1 - 20 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)