- Study guides, Class notes & Summaries

Excel Chapter 1: End-of-Chapter Quiz Already Passed Workbook An Excel file that contains one or more worksheets Spreadsheet Another name for a worksheet Cell The intersection of a column and a row Sheet Tabs The labels along the lower border of the Excel window that identify each worksheet Column A vertical group of cells in a worksheet Row A horizontal group of cells in a worksheet Cell Content Anything typed into a cell Data Text or numbers in a cell Constant Value Numbers, text, dates...

-

4 pages

Written in 2022/2023

Grade A+

BrilliantScores

Excel - Chapter 12 (2022/2023) with Verified Solutions Background An image that appears behind the worksheet data onscreen; it does not print Cell style A set of formatting options applied to worksheet cells to produce a consistent appearance for similar cells within a worksheet Comment Documents programming code, starts with an apostrophe, and appears in green in the VBA editor Keyword A special programming syntax used for a specific purpose that appears in blue in the VBA editor Locked Cel...

-

3 pages

Written in 2022/2023

Grade A+

BrilliantScores

Microsoft Excel Test Study Guide with correct answers 100% 2026 Namebox - Correct Answers On left side of formula bar, determines cell address of selected cell(s) Key Tips - Correct Answers Created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key Open - Correct Answers Command used to access a spreadsheet Exit - Correct Answers Use to close an open file and completely exit the Microsoft Exc...

-

15 pages

Written in 2026/2027

Grade A+

Wairimumburia

MOS certification exam SG with correct answers 100% 2026 Which is used to display formulas on a worksheet in Excel? - Correct Answers Show Formulas button Which items in the File tab are used to save Excel Workbooks in Various File Formats? Pick 2 - Correct Answers Export AND Save As The Compatibilitty Checker in Excel 2019 is useful for locating formats and other items in a workbook that are not used in older versions of Excel. - Correct Answers True Which common item causes compatibi...

-

8 pages

Written in 2026/2027

Grade A+

Wairimumburia

Microsoft Office Specialist Certification Exam with correct answers 100% 2026 Looking to find blanks in a table - Correct Answers =COUNTBLANK(range of cells) Looking to find no blanks in a table - Correct Answers =COUNTA(range of cells) First and last name with a space - Correct Answers =CONCAT(first name," ",last name) If this then no, if that then yes- works for numbers and words - Correct Answers =IF(#>#,"yes","no") Spark lines - Correct Answers INSERT, spar...

-

4 pages

Written in 2026/2027

Grade A+

Wairimumburia

Microsoft Word and Excel - Exam Review 2026 with correct answers 100% Text Box - Correct Answers Object that allows you to insert into it and then place it anywhere on the page Landscape - Correct Answers Print orientation where text prints along the length of the paper Justified - Correct Answers Alignment where text is even along both margins Shift - Correct Answers Key that will allow you to draw a perfect shape Home - Correct Answers Menu showing the buttons for basic functions ...

-

5 pages

Written in 2026/2027

Grade A+

Wairimumburia

MOS- Excel Expert 2019 Formulas with correct answers 100% 2026 IF function - Correct Answers Function that is used to make a decision based on a comparison. IFS function - Correct Answers Checks wether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. Switch function - Correct Answers evaluates a given value against a list of values and will return a result corresponding to the first match value. SUMIF function - Correct Answers calculate...

-

3 pages

Written in 2026/2027

Grade A+

Wairimumburia

Microsoft excel certification exam with correct answers 100% 2026 Import the comma delimited file A located in the GMetrixTemplates folder into a new worksheet. Add the import to the data model and accept all other defaults. - Correct Answers 1. Click the Data tab. 2. In the Get & Transform Data group, click From Text/CSV. 3. Browse to the GMetrixTemplates folder. 4. Select the A file and click the Import button. 5. In the A pop-up window, ensure that Delimiter is set to Comma. 6. At the b...

-

19 pages

Written in 2026/2027

Grade A+

Wairimumburia

Microsoft Excel Exam MO-210 (Microsoft 365) with correct answers 100% 2026 How do you insert multiple rows/columns at once? - Correct Answers Highlight where you want new rows/columns to be. Home tab --> Insert --> Row/Column What is =RANDBETWEEN( )? How do you format the function? - Correct Answers random number generator between two numbers (X, Y) =RANDBETWEEN(x,y) What is =SEQUENCE( )? How do you format the function? - Correct Answers produces a sequence of numbers in ...

-

7 pages

Written in 2026/2027

Grade A+

Wairimumburia

Excel Certification Exam with correct answers 100% 2026 import files - Correct Answers data>get external data specify delimitaton, column formats Comments - Correct Answers Review > new comment Wrap text - Correct Answers home > wrap text center across selection - Correct Answers home > alignment > alignment setting (arrow in BR)> Horizontal alignment insert a column in between each column - Correct Answers use CTRL when selecting the columns manually adjust co...

-

9 pages

Written in 2026/2027

Grade A+

Wairimumburia

Excel Expert - MOS 2019_Office 365 with correct answers 100% 2026 Enable Macros in a Workbook - Correct Answers 1. Go to FILE, OPTIONS, TRUST CENTER, TRUST CENTER SETTINGS. 2. Click on MACRO SETTINGS in the navigation pane, ENABLE ALL MACROS Create a Macro and copy to another workbook. - Correct Answers Go to View, MACROS. By default Macros records using Absolute reference. You can also 'Use Relative References'. ..continued Tip: Creating Macros - Correct Answers You can...

-

24 pages

Written in 2026/2027

Grade A+

Wairimumburia

MO-201: Microsoft Excel Expert Exam Review with correct answers 100% 2026 Automatic Formula Calculation - Correct Answers Default Calculation mode; excel immediately calculates values once they are entered Automatic Except for Data Tables - Correct Answers This is a good choice for worksheets that include one or more massive data tables that are slowing down re-calculation Manual - Correct Answers Excel will not automatically calculate any entries unless you manually calculate the shee...

-

14 pages

Written in 2026/2027

Grade A+

Wairimumburia

Microsoft Excel Expert Exam with correct answers 100% 2026 Create a formula that will return TRUE if a value in cell B5 is between 90 and 100 - Correct Answers AND(B5>=90,B5<=100) - AND Function requires all arguments to be true in order for it to return a TRUE value What formula would you use in order to get a TRUE value if cell C3 is greater than 14 or equal to 3 - Correct Answers OR(C3>14,C3=3) The OR function requires one of its arguments to be true in order for it to return a...

-

4 pages

Written in 2026/2027

Grade A+

Wairimumburia

MOS EXAM EXCEL with correct answers 100% 2026 Incorporate text file - Correct Answers DATA, From TEXT, select file, LOAD TO, existing or new file Create new worksheet - Correct Answers Plus button on bottom, rename, press enter Create a copy of worksheet - Correct Answers Press control key, drag over, and drop Navigate through workbook - find the BLANK - Correct Answers Name box, drop arrow, find name Navigate outside of workbook - create a hyperlink - Correct Answers Click on data,...

-

5 pages

Written in 2026/2027

Grade A+

Wairimumburia

Taking Charge of Excel: Test your skills, Part 1 with correct answers 2026 The large toolbar that stretches across the top of the Excel window is known as the Ribbon. - Correct Answer True The Excel Ribbon can be minimised or collapsed by double-clicking (single-clicking for Mac) on one of the Ribbon Tabs. - Correct Answer True Columns are referenced using letters of the alphabet. - Correct Answer True The first cell (top-left) in a standard Excel spreadsheet is known as 1A. - Correct ...

-

2 pages

Written in 2026/2027

Grade A+

jozhuarz

Taking Charge Of Excel Test Your Skills, Part 1 Questions And Answers

-

2 pages

Written in 2026/2027

Grade A+

millyphilip

Mos Exam Excel Questions And Answers

-

3 pages

Written in 2026/2027

Grade A+

millyphilip

Microsoft Excel Test Study Guide With Verified Solutions

-

10 pages

Written in 2026/2027

Grade A+

millyphilip

Microsoft Excel Expert Test Questions And Answers

-

4 pages

Written in 2026/2027

Grade A+

millyphilip

Microsoft Excel Certification Exam Questions And Answers | Graded A

-

12 pages

Written in 2026/2027

Grade A+

millyphilip

Microcomputer Apps Excel Exam Questions And Answers

-

2 pages

Written in 2026/2027

Grade A+

millyphilip

Intermediate Excel Final Questions And Answers

-

4 pages

Written in 2026/2027

Grade A+

millyphilip