Excel
All formulas begin with the... sign.
= (equal)
Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2?
=A2*B2
Which of the following functions could be used in finding the largest value from cells C2 through C25?
=MAX(C2:C25)
Which of the following formulas is written in the correct syntax?
=SUM(A1:D1)
Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of the worksheet whose cell reference is given by...
A1
If you begin typing in Excel, the characters will appear in the cell of the worksheet known as the... that has its border bolded with a green color.
Active cell.
Which operation in the formula =B5/(C6+C7)*2 will be processed first?
Addition.
Flash Fill is...
An Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data.
The... feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting.
Auto fill.
By clicking the File tab from the Excel ribbon, you have entered the... view.
Backstage.
The default name for an Excel file is...
Book1
The edges or lines around a cell are referred to as the cell's...
Border.
If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use?
Copy.
If you have a column of data in Excel that represents the cost of different items, then you will likely format that data using either an Accounting number format or a... number format.
Currency.
If you wish to MOVE the contents of one cell to another cell, which command will you use?
Cut.
To make a cell reference absolute, ... are inserted into the cell reference.
Dollar signs.
Items such as a chart title, gridlines, data labels, and so on that can be added to a chart are commonly referred to as chart...
Elements.
Once a set of cell's in Excel have been combined (or merged), they can never be split apart.
False.
Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed.
False.
What is the result of the Excel formula =AND(4=4, 15<=9)?
False.
The background of a cell is called the...
Fill color.
In Excel, a black symbol in the lower right-hand corner of the active cell. Users can click and drag the fill handle to copy cell contents or create a series.
Fill handle.
...is used to copy the formatting of one cell to other cells.
Format Painter.
...is the process of changing the appearance of cells and the overall layout of the worksheet.
Formatting.
Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color?
Home.
A linked object, such as a word, phrase, symbol, or image, that you can click to move to a different place in the same workbook, another workbook, or a website; or to open an e-mail message window is known as a...
Hyperlink.
Which page orientation prints the worksheet on paper that is wider than it is tall?
Landscape Orientation.
By default, textual data is... aligned within Excel cells.
Left.
Symbols such as +, -, and * that are used to specify the calculations to be performed in a formula are called...
Operators.
A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell...
Range.
This function adds all the numbers given in a range of cells.
SUM
Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1?
Saturday, April 12, 2014
To save an Excel workbook using a different format, location, or filename click the File tab from the Excel ribbon and choose...
Save As.
Press the... key to move the active cell one position to the right on the worksheet.
Tab.
When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called...
Templates.
What is the result of the Excel formula =OR(8=4, 5<=9)?
True.
An Excel file is referred to as a...
Workbook.
An Excel workbook can consist of multiple... or "pages" each referenced by a tab at the bottom of the Excel program window.
Worksheets.
Use the... command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it.
Wrap text.
Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents?
&
If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format...
To save a workbook in a format compatible with Excel 97-2003 versions, the file extension should be...
.xls
Excel 2016 files have names that end with a default file extension of...
.xlsx
Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell?
17%
In Excel, a... is referenced by a column letter and row number such as C5.
Cell.
What is a visual representation of data used to convey information in an easy-to-understand and attractive manner called?
Chart.
From the Backstage view Print options, select... under Settings to print all sheets in a workbook.
Entire workbook.
To automatically add row and column headers and analyze a group of related data independently from other cells in the worksheet, you can convert a range of cells to a(n)...
Excel table.
This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell.
Formula.
Which Excel ribbon tab contains the Function Library command group?
Formulas.
Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally referred to as...
Functions.
The date and page number of an Excel workbook are commonly placed in a...
Header or footer.
Combining two or more cells into a single cell creates a...
Merged cell.
Which of the following choices could be used in creating a named cell range?
MonthlyExpenses
Which of the following is a logical operator and not a comparison operator?
Not
Suppose cell D5 has a value of 17. What will be the value of cell E5 if it contains the formula =IF(D5<=10,"OK","Not Good")?
Not Good.
The mathematical rule that Excel follows to perform calculations in a formula in the proper order is called the...
Order of operations.
The area within the X- and Y-axis boundaries where the chart appears is referred to as...
Plot area.
Prior to creating a chart, it is important to...
Select/highlight the data you wish to chart.
A new Blank Workbook in Excel 2016 contains one worksheet named...
Sheet1
Cell... such as Heading and Title allow you to apply multiple formats to a cell at once.
Styles.
To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table...
Styles.
In Excel, the program name and name of the open file are displayed in the...
Title bar.
The keyboard shortcut for the Print command is...
[Ctrl] + [P].