Advance Excel

Welcome to your Advance Excel January 18, 2022

Name

Email

Contact no.

Individual

Corporate

1

You can set page border in excel Form....?

From Border tab in Format Cells dialog box

From Border tool in Formatting taskbar

You can not set page border in Excel

2

Which type of chart is useful for comparing values over categories?

Column Chart

Line Chart

pie Chart

Graph

3

In MS-excel which function will calculate the no. workdays between 15may 2021 & 10july2021

Workday

Date

Weekday

Months

4

Another name for a pre-programmed formula in Excel is

Cell

Function

Graph

Database

5

MS Excel file can NOT be directly exported as..... ?

PDF

Adobe

PPT

CSV

6

Choose correct statement....?

Add description here!

Each Excel workbook can contain multiple spreadsheets

Each Excel worksheet can contain multiple file.

Each Excel workbook can contain multiple worksheets.

Each Excel worksheet can contain multiple workbooks.

7

A formula in Excel always begins with an ____

Equal sign

Space

Enter

Break

8

In MS Excel, Workbook can be closed using keyboard shortcut ______

Ctrl+W

Ctrl+Y

ESC

9

The result is a ___ value either TRUE or FALSE.

Functional

Logical

Arithmetic

Mathematical

10

Repeats the last command or action

Ctrl + Y

Ctrl + Z

Ctrl + N

Ctrl + V

11

How do you insert developer in tab ?

Insert-Developer

Option-Developer

Option- Quick acess-Developer

All of above

12

What is the short cut for pivot table?

Alt+D+P

Ctrl +shift+P

Ctrl+P

Alt+D

13

How do you insert data in Excel through google?

By insert command

By data command

By Developer Command

None of these

14

Importance of Macros in excel?

It helps to do coding

To create tabs

To Automate task

15

what is the use of trim function?

trim whole data

trim immediate data

trim unwanted space

trim cells