MS General
What is the symbol for an addition?
+
The intersection of a column and a row in a worksheet is called____
Cell
What is the keyboard shortcut for copying cells in Excel?
Ctrl + C
To find the Largest number in a range of numbers in excel we use ....................
The MAX function
What do we call a page in presentation in PowerPoint?
Slide
What is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications
Microsoft Excel
Counts cells as specified (criteria) , we use the function of ...........
=COUNTIF function
How can you create a drop-down list in Excel?
Using the Data Validation feature
In Excel you can get validation on which tab?
Data
What happens when you select first and second slide and then try to insert the new slide?
New slide will be inserted as third slide
To create a table from a range , we need to press on ...........................
CTRL + T
When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:
Chart
____ is the correct syntax of IF() Function.
=IF (logical_test, [value_if_true], [value_if_false])
What match type returns the exact value?
0(zero) or FALSE
if you want to get the RGB from an image on PowerPoint , i use the tool ?
Eye Dropper
The ------------------ is a toolbar at the top of the window that organizes commands and tools into tabs, making them easy to find and use
"Ribbon" in Microsoft Office applications
We would use ----------- to sum the number of retailers in the country who reside in a single zip code
SUMIF
The _______ function adds all of the indicated cells together and divides by the total number of cells.
Average
It performs a logical test and returns one value for a TRUE result and another for a FALSE result
What is "IF" function?
If i want to get the quarter of a specified date , which function should i use?
Round Up
Which functions would you use, if you wished to quickly create smaller lists out of a much larger list on an Excel worksheet?
Filter
Easily arrange complex data in a --------------
Pivot Table
What are the two ways to access the styling commands in Excel?
First Way - The Ribbon
Second Way - Formatting menu, by right clicking cells
If you have a well-structured table, with information arranged vertically, and a column on the left which you can use to match a row, you can probably use this function.
VLOOKUP
How can you quickly select an entire worksheet in Excel?
Click the corner button