Microsoft Excel Quiz: Test Your GK!

Pressing the Ctrl+B key combination is a shortcut for making the font in the selected cell bold. This means that when you have a cell selected in a spreadsheet or a text document, pressing Ctrl+B will apply the bold formatting to the text in that cell.

The correct answer is "Chart." The icon on the standard toolbar is used for creating and inserting charts into a document or spreadsheet. This allows users to visually represent data in the form of graphs or charts, making it easier to analyze and understand the information presented. It provides a visual representation of data trends, patterns, and comparisons, making it an essential tool for data analysis and presentation.

The given correct answer is the AutoSum button. The AutoSum button is used to quickly calculate the sum of a range of numbers in a spreadsheet or a table. It automatically selects the range of numbers that are adjacent to it and inserts the SUM function to calculate the total. This button is commonly used in spreadsheet applications like Microsoft Excel to simplify the process of summing up data.

The correct answer is Format Painter. The Format Painter icon on the standard toolbar is used to copy the formatting of a selected object or text and apply it to another object or text. It allows for quick and consistent formatting across different parts of a document or presentation.

The correct answer is Ctrl+Shift+F. This keyboard shortcut is a shortcut to select the font option from the Formatting toolbar. By pressing Ctrl+Shift+F, users can quickly access and modify the font settings of their text without having to navigate through the toolbar manually.

The result from this vlookup() function will be "NA". This is because the function is searching for the value "Bookshelf Library" in the "Company" column and returning the corresponding value from the "Rebate" column. Since "Bookshelf Library" is found in the "Company" column, the function will return the value "NA" from the "Rebate" column.

The Freeze Panes option is available in the Windows menu. This option allows users to freeze specific rows or columns in a spreadsheet so that they remain visible while scrolling through the rest of the data. By selecting the Freeze Panes option, users can improve the visibility and organization of their data by keeping important information in view at all times.

The shortcut key Ctrl+1 is used to open a cell format window in Microsoft Excel. This shortcut allows users to quickly access the Format Cells dialog box, where they can modify the formatting of selected cells. By pressing Ctrl+1, users can easily change the number format, font, alignment, border, fill, and other formatting options for the selected cells. This shortcut helps to save time and streamline the formatting process in Excel.

Yes, the color of the worksheet tabs in a workbook can be changed. The shortcut key to change the color of the worksheet tabs is Alt+O+H+T.