Skip to content

Desi banjara

  • “Confidence comes not from always being right but from not fearing to be wrong.” Peter T. Mcintyre Motivational & Inspirational Quotes
  • Cute & Romantic Good Morning Wishes Good Morning Wishes
  • Microsoft PL-900 Certification Exam Practice Questions – 2 PL-900: Microsoft Power Platform Fundamentals
  • Inspirational Quotes- Winning isn’t everything Inspirational Quotes
  • Azure Data Factory Azure Data Factory
  • Microsoft AZ-104 Certification Exam Practice Questions – 2 Microsoft AZ-104 Certification Exam
  • Sample Exam Questions 2: AZ-300: Microsoft Azure Architect Technologies AZ-300: Microsoft Azure Architect Technologies Exam
  • “We must embrace pain and burn it as fuel for our journey.”– Kenji Miyazawa Motivational & Inspirational Quotes

Interview questions – Microsoft Excel

Posted on April 19, 2017 By DesiBanjara No Comments on Interview questions – Microsoft Excel



1- What is Microsoft Excel?

Microsoft Excel is an electronic spreadsheet program, created by multiple highly skilled engineers from Microsoft. It enables users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and column.

2- How do you create a spreadsheet in Microsoft Excel?

When you start Excel without specifying a document to open you get a blank workbook in a new workbook window.

This workbook, temporarily named Book1, contains three blank worksheets
(Sheet1, Sheet2, and Sheet3). To begin to work on a new spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window.



3- How do you save a spreadsheet in Microsoft Excel?

Click the Save button on the Quick Access toolbar or press Ctrl+S; then designate the drive and folder directory where the file should be located.

4- What is the shortcut to put the filter on data in Microsoft Excel?

Ctrl+Shift+L is the shortcut key to put the filter in data.



5- What is the easiest solution to reduce the file size?

  • Find the last cell that contains data in the sheet. Delete all rows and columns after this cell
  • To delete the rows, press the key Shift+Space then press Ctrl+Shift+Down on your keyboard
  • Rows will get selected till the last row. Press Ctrl+- on the keyboard to delete the blank rows
  • To delete the column, Press the key Ctrl+Space then press Ctrl+Shift+Right Arrow key on your keyboard
  • Columns will get selected till the last row
  • Press Ctrl+- on the keyboard to delete the blank columns

6- What is the difference between function and formula in Microsoft Excel?

Formula:- In excel formula are the statement which is written by the user (user-created) to be calculated. A formula can contain values, cell references, defined names, and functions.

Functions:- Functions are in-built codes provided in MS-Excel, such as COUNT, SUM, AVERAGE etc. And, if additional functions are required we can create through VBA. This will carry out an operation of some kind and provide an output value. Functions are used inside formulas.



Interview questions, Microsoft Excel Tags:AVERAGE, COUNT, filter on data, function and formula, Interview questions, Microsoft Excel, MS-Excel, spreadsheet, SUM, worksheets

Post navigation

Previous Post: Interview questions – Microsoft Word
Next Post: Best Get Well Soon Wishes / Messages

Related Posts

  • Asp.Net WebApi Interview Questions – Cont. ASP.NET Web API
  • Interview question: What is the difference between GetType() and typeof()? C# development
  • Interview question: What is Jagged Array in C#? C# development
  • SOLID Design Principles C# development
  • C# Interview question: How encapsulation is implemented in C#? C# development
  • ASP.Net MVC Interview Questions ASP.Net MVC

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *



Archives

  • February 2023
  • February 2022
  • June 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • April 2020
  • December 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • January 2018
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • August 2015
  • May 2015
  • April 2014
  • November 2013

Categories

  • Acer
  • Amazon AWS Certification Exam
  • Amazon Kindle
  • Android phones
  • ASP.Net MVC
  • ASP.NET Web API
  • AWS DevOps Engineer Professional Exam
  • AZ-300: Microsoft Azure Architect Technologies Exam
  • Azure Active Directory
  • Azure App Services
  • Azure Data Factory
  • Azure Logic Apps
  • Azure Mobile Apps
  • Azure Virtual Machine
  • Best Wishes Messages
  • birthday messages for boyfriend
  • Birthday messages For Girlfriend
  • Birthday Wishes
  • Birthday Wishes For Mom
  • Business
  • C# development
  • Cameras
  • Canon
  • Cloud
  • Cloud services
  • digital-cameras
  • Diwali
  • Entrepreneurship
  • eReaders
  • Family Quotes
  • Family Quotes
  • Friendship Quotes
  • Gadgets
  • Games
  • Get Well Soon Messages
  • GIT
  • Good Morning Wishes
  • Google
  • Gratitude Quote
  • Guru Nanak Jayanti
  • Halloween
  • Happiness Quote
  • Happy Diwali Wishes
  • Happy Independence Day Wishes
  • Happy New Year Wishes
  • HTC
  • HTC One
  • HTML
  • I Miss You Messages
  • Inspirational Quotes
  • Inspirational Travel Quotes
  • Interview questions
  • IT/Software development
  • Leadership Quote
  • Life lessons
  • Love Quotes
  • Love shayari
  • Messages
  • Microsoft AI-900 Certification Exam
  • Microsoft AZ-104 Certification Exam
  • Microsoft AZ-204 Certification Exam
  • Microsoft AZ-900 Certification Exam
  • Microsoft Azure
  • Microsoft Azure certifications
  • Microsoft Exam AZ-220
  • Microsoft Excel
  • Microsoft Office
  • Microsoft word
  • Mobile phones
  • Motivational & Inspirational Quotes
  • Nature Quotes
  • Nexus
  • Nikon
  • Pixels
  • PL-200: Microsoft Power Platform Functional Consultant Certification
  • PL-900: Microsoft Power Platform Fundamentals
  • postman
  • Quotes
  • Robin Sharma
  • Samsung Galaxy S5
  • Self improvement quotes
  • Self-Confidence Quote
  • SonarQube
  • Sony PlayStation 4
  • SQL
  • SQL Server
  • Success Quotes
  • Travel Quotes
  • Uncategorized
  • Uplifting Quotes
  • WCF (Windows Communication Foundation)
  • Web development
  • Wishes
  • Wishes for Newborn Baby

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org



Recent Posts

  • Azure Data Factory
  • What is Azure Active Directory?
  • Azure Virtual Machine
  • Azure Logic Apps
  • Azure Mobile Apps

Recent Comments

  • Yosianus on Error while sending json model in POST request to web API service using postman
  • PL-200: Microsoft Power Platform Functional Consultant Certification – Exam Practice Questions PL-200: Microsoft Power Platform Functional Consultant Certification
  • Microsoft AI-900 Certification Exam Practice Questions Microsoft AI-900 Certification Exam
  • You are my little angel and no matter how many years pass, you will always be my sweet little angel. I wish you faith, courage and determination to succeed in all walks of life. May you have a great and rocking life ahead. We are always there to support you. Wishing you a very Happy Birthday. Birthday Wishes
  • “People don’t take trips, trips take people.” – John Steinbeck Quotes
  • Hope your special day offers you all what your heart desires. Birthday Wishes
  • C# Interview question: How encapsulation is implemented in C#? C# development
  • “It is not the mountain we conquer, but ourselves.” Sir Edmund Hillary Motivational & Inspirational Quotes
  • Nikon D3400 Cameras

Copyright © 2023 Desi banjara.

Powered by PressBook News WordPress theme