HOME
ABOUT US
ONLINE TEST
FEEDBACK FORM
CONTACT US
Trainer Enrollment Form

Advance Excel

By : Ntpr-webdevelopment - July 11 , 2021

Welcome to your Advance Excel September 19, 2021

Name

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 toolbar

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 create drop down menu

To Automate task

15. what is the use of trim function?

trim whole data

trim immediate data

trim unwanted space

trim cells

Time is Up!

Time's up

ABOUT NTPR
REACH US
PRIVACY POLICY
TERMS & CONDITIONS
CERTIFICATION

Login

Remember Me

Forgot Password?

Create a new account

Insert/edit link

Enter the destination URL

URL

Link Text

Open link in a new tab

Or link to existing content

No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.