Excel Essential Training | 100% Correct Answers | Verified | Latest 2024 Version

Excel Essential Training | 100% Correct Answers | Verified | Latest 2024 Version In Excel, a file is a ____________. - workbook You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - now says "dog" The most effective way to add up five different cells in a row is to _____ (after typing the equal sign into the formula bar). - use the function SUM, type an open parenthesis, and the highlight the five cells What is true of formatting cells to a particular category, such as Accounting or Currency? - This adjusts the display of your data, but not the data itself When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. - simply complete the action. Excel maintains the formulas for you Which of the following is not type of Sparkline (mini chart)? - Scatter _____ means "exact match" when creating a VLOOKUP. - FALSE If you highlight a column and then click the Sort alphabetically button (A-Z), - only the data in the column is sorted All of the following are required to begin creating a PivotTable, except: _____. - Begin with an equal sign and open parenthesis A macro is a way to automate a sequence of steps in your work. - true Excel is _____. - all of these answers You highlight a column of data in a worksheet. In the status bar below, you'll see all of the following by default, except: _____. - Minimum and Maximum values You can create a new workbook by pressing Ctrl+n on your keyboard, or for a greater variety of options, - navigating to File New Date entries are numbers and, by default, - lined up on the right side of the cell Save is a safer way to save your work than Save As. - False When you copy a formula into an adjacent cell, Excel will adjust the corresponding columns/rows to fit that cell. - true How can you access font styles and effects other than what is presented by default on the Home ribbon tab? - click the dialog box launcher in the bottom right-hand corner of the Font section How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? - highlight only the data where you'd like to insert a row. Right-clickInsert...Shift cells down All of the following are ways to print your spreadsheets with greater efficiency, except: - Remove all headers and footers To create a chart, you begin by _____. - selecting data Which of the following is not type of Sparkline (mini chart)? - Scatter To see multiple worksheets from different files at once, - Click on the view tab Arrange All A fast way to make a copy of a sheet in the same workbook is to drag the sheet tab with the _____ key held down. - CRTL When creating an IF function, a _____ separates the "logical test" from the "value if true/false". - comma _____ means "exact match" when creating a VLOOKUP. - FALSE If you lock a cell and then protect the worksheet,