2. A bar near the top of the Excel workspace, where you can select commands, such as File, Edit, View, Insert, Format, Tools, Data, Window, and Help, to manipulate data you have entered, is called
a. the formula bar.
b. the formatting toolbar.
c. the menu bar.
d the standard toolbar.
Answers
Answer:
c. the menu bar
Explanation:
You can call it menu bar or tool bar
Answer:
After a file has been opened, the filename appears in which of the following?
title bar
footer
header
Description pane
You can assign keywords so that others can search for your documents online.
True
False
To access an Excel template, you can click the File tab and then click New.
True
False
Which Excel feature helps you quickly enter existing data into adjacent cells?
AutoComplete
AutoData
QuickComplete
QuickData
Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
Cell pointer
Column marker
Fill handle
Formula bar
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
Page Layout view is useful when preparing your data for printing.
True
False
Once you name a range, you can change the size of the range using the Name Manager.
True
False
Click the FILE tab to get to Backstage view.
True
False
You do not have the ability to modify the number of default worksheets in a workbook.
True
False
Which of the following places a duplicate of a selection in the Office Clipboard?
Paste
Document properties
Copy
Range
Using the Delete key removes both text and formats from a cell.
True
False
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
True
False
The formula bar is found at the bottom of the Excel window.
True
False
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Open
Which of the following statement are true in Excel?
A worksheet is the same as a spreadsheet
A workbook is the same as a worksheet
Per the order of operations, which of the following is calculated first?
Addition (+) and subtraction (−) (left to right)
Exponentiation (ˆ)
Percent (%)
Negative number (−)
You have kept your personal budget in an Excel workbook for the last 15 years. You need to find that one purchase that you made from Contoso 6 years ago. Or was it 11 years ago? What is the quickest way to find that purchase?
sort your worksheet by date and review the purchases from 6 to 11 years ago
type the Name Manager button and look for "Contoso"
type Ctrl+F to open Find and Replace, type "Contoso", and search
type Ctrl+F to open Find and Replace, replace the word "Contoso" with bold red font to make it easy to find
Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas?
Cell pointer
Column marker
Fill handle
Formula bar
To remove only the formats from a cell, you can use the Delete key.
True
False
What will happen when you click the button highlighted above?
the selected text will be bold, Calibri, 11 pt, yellow font
the selected text will be bold, Calibri, 12 pt, yellow font
the selected text will be bold, Calibri, 11 pt, highlighted in yellow
the selected text will be bold, Calibri, 12 pt, highlighted in yellow
Ctrl + F displays Backstage view.
True
False
If you select cell B4 above, click Delete, and then type "Region" in the same cell, what will happen?
the word "Region" will be in default black, unbolded text
the word "Region" will be in red, unbolded text
the word "Region" will be in default black, bolded text
the word "Region" will be in red, bolded text
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
File format
Worksheet
File sheet
File range
Press Ctrl + Home to go to cell A1.
True
False